home *** CD-ROM | disk | FTP | other *** search
/ Programmer Plus 2007 / Programmer-Plus-2007.iso / Programming / SQL and Data Base / Logic Works ERwin 3.5 / data.1 / ERTMPL32.DLL / RCDATA / 302 < prev    next >
Unknown  |  1998-01-30  |  778 b 
open in: MacOS 8.1     |     Win98     |     DOS

view JSON data     |     view as text


This file was not able to be converted.
This format is not currently supported by dexvert.

ConfidenceProgramDetectionMatch TypeSupport
100% file Par archive data default (weak)
99% file data default
100% dexmagic Visual Novel DPK Archive default (weak)
100% dexmagic PrintFox/Pagefox WEAK default


hex view
+--------+-------------------------+-------------------------+--------+--------+
|00000000| 50 41 52 45 4e 54 20 55 | 50 44 41 54 45 20 43 41 |PARENT U|PDATE CA|
|00000010| 53 43 41 44 45 00 20 20 | 2f 2a 20 45 52 77 69 6e |SCADE.  |/* ERwin|
|00000020| 20 42 75 69 6c 74 69 6e | 20 25 44 61 74 65 74 69 | Builtin| %Dateti|
|00000030| 6d 65 20 2a 2f 0d 0a 20 | 20 2f 2a 20 25 50 61 72 |me */.. | /* %Par|
|00000040| 65 6e 74 20 25 56 65 72 | 62 50 68 72 61 73 65 20 |ent %Ver|bPhrase |
|00000050| 25 43 68 69 6c 64 20 4f | 4e 20 50 41 52 45 4e 54 |%Child O|N PARENT|
|00000060| 20 55 50 44 41 54 45 20 | 43 41 53 43 41 44 45 20 | UPDATE |CASCADE |
|00000070| 2a 2f 0d 0a 20 20 69 66 | 0d 0a 20 20 20 20 2f 2a |*/..  if|..    /*|
|00000080| 20 25 25 50 61 72 65 6e | 74 50 4b 28 22 20 6f 72 | %%Paren|tPK(" or|
|00000090| 22 2c 75 70 64 61 74 65 | 29 20 2a 2f 0d 0a 20 20 |",update|) */..  |
|000000a0| 20 20 25 50 61 72 65 6e | 74 50 4b 28 22 20 6f 72 |  %Paren|tPK(" or|
|000000b0| 22 2c 75 70 64 61 74 65 | 29 0d 0a 20 20 62 65 67 |",update|)..  beg|
|000000c0| 69 6e 0d 0a 20 20 20 20 | 69 66 20 40 6e 75 6d 72 |in..    |if @numr|
|000000d0| 6f 77 73 20 3d 20 31 0d | 0a 20 20 20 20 62 65 67 |ows = 1.|.    beg|
|000000e0| 69 6e 0d 0a 20 20 20 20 | 20 20 73 65 6c 65 63 74 |in..    |  select|
|000000f0| 20 25 4a 6f 69 6e 50 4b | 50 4b 28 40 69 6e 73 2c | %JoinPK|PK(@ins,|
|00000100| 69 6e 73 65 72 74 65 64 | 2c 22 20 3d 20 22 2c 22 |inserted|," = ","|
|00000110| 2c 20 22 29 0d 0a 20 20 | 20 20 20 20 20 20 66 72 |, ")..  |      fr|
|00000120| 6f 6d 20 69 6e 73 65 72 | 74 65 64 0d 0a 20 20 20 |om inser|ted..   |
|00000130| 20 20 20 75 70 64 61 74 | 65 20 25 43 68 69 6c 64 |   updat|e %Child|
|00000140| 0d 0a 20 20 20 20 20 20 | 73 65 74 0d 0a 20 20 20 |..      |set..   |
|00000150| 20 20 20 20 20 2f 2a 20 | 20 25 25 4a 6f 69 6e 46 |     /* | %%JoinF|
|00000160| 4b 50 4b 28 25 43 68 69 | 6c 64 2c 40 69 6e 73 2c |KPK(%Chi|ld,@ins,|
|00000170| 22 20 3d 20 22 2c 22 2c | 22 29 20 2a 2f 0d 0a 20 |" = ",",|") */.. |
|00000180| 20 20 20 20 20 20 20 25 | 4a 6f 69 6e 46 4b 50 4b |       %|JoinFKPK|
|00000190| 28 25 43 68 69 6c 64 2c | 40 69 6e 73 2c 22 20 3d |(%Child,|@ins," =|
|000001a0| 20 22 2c 22 2c 22 29 0d | 0a 20 20 20 20 20 20 66 | ",",").|.      f|
|000001b0| 72 6f 6d 20 25 43 68 69 | 6c 64 2c 69 6e 73 65 72 |rom %Chi|ld,inser|
|000001c0| 74 65 64 2c 64 65 6c 65 | 74 65 64 0d 0a 20 20 20 |ted,dele|ted..   |
|000001d0| 20 20 20 77 68 65 72 65 | 0d 0a 20 20 20 20 20 20 |   where|..      |
|000001e0| 20 20 2f 2a 20 20 25 25 | 4a 6f 69 6e 46 4b 50 4b |  /*  %%|JoinFKPK|
|000001f0| 28 25 43 68 69 6c 64 2c | 64 65 6c 65 74 65 64 2c |(%Child,|deleted,|
|00000200| 22 20 3d 20 22 2c 22 20 | 61 6e 64 22 29 20 2a 2f |" = "," |and") */|
|00000210| 0d 0a 20 20 20 20 20 20 | 20 20 25 4a 6f 69 6e 46 |..      |  %JoinF|
|00000220| 4b 50 4b 28 25 43 68 69 | 6c 64 2c 64 65 6c 65 74 |KPK(%Chi|ld,delet|
|00000230| 65 64 2c 22 20 3d 20 22 | 2c 22 20 61 6e 64 22 29 |ed," = "|," and")|
|00000240| 0d 0a 20 20 20 20 65 6e | 64 0d 0a 20 20 20 20 65 |..    en|d..    e|
|00000250| 6c 73 65 0d 0a 20 20 20 | 20 62 65 67 69 6e 0d 0a |lse..   | begin..|
|00000260| 20 20 20 20 20 20 73 65 | 6c 65 63 74 20 40 65 72 |      se|lect @er|
|00000270| 72 6e 6f 20 3d 20 33 30 | 30 30 36 2c 0d 0a 20 20 |rno = 30|006,..  |
|00000280| 20 20 20 20 20 20 20 20 | 20 20 20 40 65 72 72 6d |        |   @errm|
|00000290| 73 67 20 3d 20 27 43 61 | 6e 6e 6f 74 20 63 61 73 |sg = 'Ca|nnot cas|
|000002a0| 63 61 64 65 20 22 25 50 | 61 72 65 6e 74 22 20 55 |cade "%P|arent" U|
|000002b0| 50 44 41 54 45 20 62 65 | 63 61 75 73 65 20 6d 6f |PDATE be|cause mo|
|000002c0| 72 65 20 74 68 61 6e 20 | 6f 6e 65 20 72 6f 77 20 |re than |one row |
|000002d0| 68 61 73 20 62 65 65 6e | 20 61 66 66 65 63 74 65 |has been| affecte|
|000002e0| 64 2e 27 0d 0a 20 20 20 | 20 20 20 67 6f 74 6f 20 |d.'..   |   goto |
|000002f0| 65 72 72 6f 72 0d 0a 20 | 20 20 20 65 6e 64 0d 0a |error.. |   end..|
|00000300| 20 20 65 6e 64 0d 0a 00 | 11 27                   |  end...|.'      |
+--------+-------------------------+-------------------------+--------+--------+